Excel Basics – What are Combination Charts and How to Make One?

Share

Facebook
Twitter
LinkedIn

This post is part of SpreadCheats series, read the rest of posts and cheat excel to become productive.

A combination chart is when you combine two different charts to make one. A popular example of combination charts is a line & bar graph combination. See below illustration:

excel-combination-charts

Today we will learn how to create a simple combination chart.

  1. For our combination chart, we will use the following data of Sales & Profits
    combo-chart-data
  2. First we will make a simple bar chart for the sales data. Just select the Sales data table, go to insert > chart and specify type as “column chart” (this is the default selection btw). Once you are done, the chart looks like this:
    first-part-combo-chart
  3. Now, select the profits data, press ctrl+c to copy it to clip board, and select the sales chart you have created above, and press ctrl+v to paste this data in to the sales chart. Essentially we are adding one more series of data to the sales chart.
  4. Now the chart should look like below. Right click on the new series (profits) and select “chart type”.
    combination-charts-howto
  5. From the chart type dialog change the type of chart from “column” to “line” (or whatever other type you fancy)
  6. That is all, you have successfully created a combination chart in excel.

Download the Excel Combination Chart Tutorial workbook and learn by experimenting.

As you can probably guess by now, there are some restrictions on what you can mix though. Best way to learn and understand combination charts is by experimenting. Just select one of the data series and change the chart type.

Like this ? Read other SpreadCheats to make your day to day spreadsheeting a breeze.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”

  1. Danny says:

    Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.

    I added a new sheet, and named the ranges for Sara and James.

    Maybe something like:
    B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
    C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
    D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
    E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))

    Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.

Leave a Reply